package com.shycloud.mido.task.api.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

import java.util.Date;

/**
 * 学生详细信息表
 */
@Data
@TableName(value = "org_student_detailed")
public class OrgStudentDetailed {
	/**
	 * 主键
	 */
	@TableId(value = "id", type = IdType.UUID)
	private String id;

	/**
	 * 机构id
	 */
	@TableField(value = "org_id")
	private Integer orgId;

	/**
	 * member关联id
	 */
	@TableField(value = "member_id")
	private String memberId;

	/**
	 * 证件类型
	 */
	@TableField(value = "id_type")
	private String idType;

	/**
	 * 证件号码
	 */
	@TableField(value = "id_number")
	private String idNumber;

	/**
	 * 邮件地址
	 */
	@TableField(value = "email_address")
	private String emailAddress;

	/**
	 * 微信号码
	 */
	@TableField(value = "wx_number")
	private String wxNumber;

	/**
	 * qq号码
	 */
	@TableField(value = "qq_number")
	private String qqNumber;

	/**
	 * 邮编
	 */
	@TableField(value = "postal_code")
	private String postalCode;

	/**
	 * 就读学校
	 */
	@TableField(value = "school")
	private String school;

	/**
	 * 年级
	 */
	@TableField(value = "grade")
	private String grade;

	/**
	 * 入学时间
	 */
	@TableField(value = "enter_time")
	private Date enterTime;

	/** 所属机构的虚拟账号 */
	@TableField(value = "belong_to")
	private String belongTo;

	/** 上课需求 */
	@TableField(value = "demand_remarks")
	private String demandRemarks;

	/** 联系人备注 */
	@TableField(value = "liaison_remarks")
	private String liaisonRemarks;

	/** 状态(0:意向,1:试听,2:已安排试听;8:正式,) */
	@TableField(value = "status")
	private String status;

	/** 创建者 */
	@TableField(value = "create_user")
	private String createUser;

	/** 创建时间 */
	@TableField(value = "create_time")
	private Date createTime;

	/** 修改者 */
	@TableField(value = "update_user")
	private String updateUser;

	/** 修改时间 */
	@TableField(value = "update_time")
	private Date updateTime;

	/**
	 * 逻辑删除标示 默认是有效数据，默认值0
	 */
	@TableField(value = "del_flag")
	private String delFlag;

	/**
	 * 学生姓名
	 */
	@TableField(value = "name")
	private String name;

	/**
	 * 联系人姓名
	 */
	@TableField(value = "liaison_name")
	private String liaisonName;

	/**
	 * 联系方式
	 */
	@TableField(value = "liaison_phone")
	private String liaisonPhone;

	/**
	 * 当前所处阶段可布置作业数目(一年平均划分为6个阶段)
	 */
	@TableField(value = "cur_assginment_balance")
	private Integer curAssginBal;

	/**
	 * 下一个所处阶段可布置作业数目(一年平均划分为6个阶段)
	 */
	@TableField(value = "next_assginment_balance")
	private Integer nextAssginBal;

	public static final String COL_ID = "id";

	public static final String COL_ORG_ID = "org_id";

	public static final String COL_MEMBER_ID = "member_id";

	public static final String COL_ID_TYPE = "id_type";

	public static final String COL_ID_NUMBER = "id_number";

	public static final String COL_EMAIL_ADDRESS = "email_address";

	public static final String COL_WX_NUMBER = "wx_number";

	public static final String COL_QQ_NUMBER = "qq_number";

	public static final String COL_POSTAL_CODE = "postal_code";

	public static final String COL_SCHOOL = "school";

	public static final String COL_GRADE = "grade";

	public static final String COL_ENTER_TIME = "enter_time";

	public static final String COL_BELONG_TO = "belong_to";

	public static final String COL_DEMAND_REMARKS = "demand_remarks";

	public static final String COL_LIAISON_REMARKS = "liaison_remarks";

	public static final String COL_STATUS = "status";

	public static final String COL_CREATE_USER = "create_user";

	public static final String COL_CREATE_TIME = "create_time";

	public static final String COL_UPDATE_USER = "update_user";

	public static final String COL_UPDATE_TIME = "update_time";

	public static final String COL_DEL_FLAG = "del_flag";

	public static final String COL_NAME = "name";

	public static final String COL_LIAISON_NAME = "liaison_name";

	public static final String COL_LIAISON_PHONE = "liaison_phone";
}